package com.deyuanyun.pic.ctrl.excelImport;

import com.deyuanyun.pic.common.validator.annotations.DataValidate;
import com.deyuanyun.pic.ctrl.annotation.*;
import com.deyuanyun.pic.ctrl.util.AutoImportInterface;
import com.deyuanyun.pic.ctrl.validatefun.AutoPile;
import com.deyuanyun.pic.ctrl.validatefun.EnumValidata;
import com.deyuanyun.pic.ctrl.validatefun.PipeLineValidata;

import java.util.Date;

/**

说明:Z:\excel\涂层检测与评价\4外涂层分级评价（漏损点密度评价）表（导入、导出）.xls

**/
@DbTable(name="PIC_CTRL_EXINSP_OCGRADE",startRow=4,sumCell=14,excelName="外涂层分级评价（漏损点密度评价）表.xls")
public class PicCtrlExinspOcgradeExcel implements AutoImportInterface
{

      /**
      * 管道名称
      */
      @Head( name="管道名称",row=2,cell=0)
      @DbFiled( name="PIPE_LINE_ID" ,type="CHAR")
      @DataValidate(notNull = true,myFunction = PipeLineValidata.class,myFunctionMessage="管道信息与项目要求管道不一致")
      private String pipeLineId;

      /**
      * 起点测试桩编号
      */
      @Head( name="起点测试桩编号",row=2,cell=1)
      @DbFiled( name="BEGIN_STATION_NUMBER" ,type="CHAR")
      @DataValidate(notNull = true,myFunction = AutoPile.class,myFunctionMessage="测试桩不存在")
      private String beginStationNumber;

      /**
      * 终点测试桩编号
      */
      @Head( name="终点测试桩编号",row=2,cell=2)
      @DbFiled( name="END_STATION_NUMBER" ,type="CHAR")
      @DataValidate(notNull = true,myFunction = AutoPile.class,myFunctionMessage="测试桩不存在")
      private String endStationNumber;

      /**
      * 评价管段长度（m）
      */
      @Head( name="评价管段长度（m）",row=2,cell=3)
      @DbFiled( name="EVALUATION_OF_PIPE_LENGTH" ,type="NUMBER")
      @DataValidate(notNull = true)
      private String evaluationOfPipeLength;

      /**
      * 漏损点数量（个）
      */
      @Head( name="漏损点数量（个）",row=2,cell=4)
      @DbFiled( name="LEAKAGE_POINT_NUMBER" ,type="NUMBER")
      @DataValidate(notNull = true)
      private String leakagePointNumber;

      /**
      * P（处/100m）
      */
      @Head( name="P（处/100m）",row=3,cell=5)
      @DbFiled( name="PVALUE" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String pvalue;

      /**
      * 外涂层等级
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.FaultGradeEnum.class,valMethod="getVal")
      @Head( name="外涂层等级",row=3,cell=6)
      @DbFiled( name="COATING_GRADE" ,type="NUMBER")
      @DataValidate(notNull = true,myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String coatingGrade;

      /**
      * 检测方法
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.TestingMethodEnum.class,valMethod="getVal")
      @Head( name="检测方法",row=2,cell=7)
      @DbFiled( name="TESTING_METHOD" ,type="VARCHAR2")
      @DataValidate(notNull = true,myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String testingMethod;

      /**
      * 检测日期
      */
      @Head( name="检测日期",row=2,cell=8)
      @DbFiled( name="TESTING_DATE" ,type="DATE")
      @DataValidate(type = Date.class,notNull = true)
      private String testingDate;

      /**
      * 检测单位
      */
      @Head( name="检测单位",row=2,cell=9)
      @DbFiled( name="TESTING_COMPANY" ,type="VARCHAR2")
      @DataValidate(notNull = true,lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String testingCompany;

      /**
      * 记录人
      */
      @Head( name="记录人",row=2,cell=10)
      @DbFiled( name="RECORDER" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      @AutoLoginUser
      private String recorder;

      /**
      * 记录时间
      */
      @Head( name="记录时间",row=2,cell=11)
      @DbFiled( name="RECORD_TIME" ,type="DATE")
      @DataValidate(type = Date.class)
      @AutoDate
      private String recordTime;

      /**
      * 备注
      */
      @Head( name="备注",row=2,cell=12)
      @DbFiled( name="REMARKS" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String remarks;

      /**
      * id
      */
      @DbFiled( name="ID_")
      @AutoId
      private String id;

    @AutoExinspTask
    @DbFiled( name="EXINSP_TASK_ID",type="VARCHAR2")
    private String exinspTaskId;

    @DbFiled( name="DATA_STATED",type="VARCHAR2")
    private String dataStated;

    @DbFiled( name="IS_NEWEST",type="NUMBER")
    private String isNewset;

    public String getIsNewset() {
        return isNewset;
    }

    public void setIsNewset(String isNewset) {
        this.isNewset = isNewset;
    }
    public String getDataStated() {
        return dataStated;
    }

    public void setDataStated(String dataStated) {
        this.dataStated = dataStated;
    }

    public String getExinspTaskId() {
        return exinspTaskId;
    }

    public void setExinspTaskId(String exinspTaskId) {
        this.exinspTaskId = exinspTaskId;
    }


    public String getPipeLineId()
    {

        return  this.pipeLineId;
    }
    public void setPipeLineId(String pipeLineId)
    {

      this.pipeLineId=pipeLineId;
    }


    public String getBeginStationNumber()
    {

        return  this.beginStationNumber;
    }
    public void setBeginStationNumber(String beginStationNumber)
    {

      this.beginStationNumber=beginStationNumber;
    }


    public String getEndStationNumber()
    {

        return  this.endStationNumber;
    }
    public void setEndStationNumber(String endStationNumber)
    {

      this.endStationNumber=endStationNumber;
    }


    public String getEvaluationOfPipeLength()
    {

        return  this.evaluationOfPipeLength;
    }
    public void setEvaluationOfPipeLength(String evaluationOfPipeLength)
    {

      this.evaluationOfPipeLength=evaluationOfPipeLength;
    }


    public String getLeakagePointNumber()
    {

        return  this.leakagePointNumber;
    }
    public void setLeakagePointNumber(String leakagePointNumber)
    {

      this.leakagePointNumber=leakagePointNumber;
    }


    public String getPvalue()
    {

        return  this.pvalue;
    }
    public void setPvalue(String pvalue)
    {

      this.pvalue=pvalue;
    }


    public String getCoatingGrade()
    {

        return  this.coatingGrade;
    }
    public void setCoatingGrade(String coatingGrade)
    {

      this.coatingGrade=coatingGrade;
    }


    public String getTestingMethod()
    {

        return  this.testingMethod;
    }
    public void setTestingMethod(String testingMethod)
    {

      this.testingMethod=testingMethod;
    }


    public String getTestingDate()
    {

        return  this.testingDate;
    }
    public void setTestingDate(String testingDate)
    {

      this.testingDate=testingDate;
    }


    public String getTestingCompany()
    {

        return  this.testingCompany;
    }
    public void setTestingCompany(String testingCompany)
    {

      this.testingCompany=testingCompany;
    }


    public String getRecorder()
    {

        return  this.recorder;
    }
    public void setRecorder(String recorder)
    {

      this.recorder=recorder;
    }


    public String getRecordTime()
    {

        return  this.recordTime;
    }
    public void setRecordTime(String recordTime)
    {

      this.recordTime=recordTime;
    }


    public String getRemarks()
    {

        return  this.remarks;
    }
    public void setRemarks(String remarks)
    {

      this.remarks=remarks;
    }


    public String getId()
    {

        return  this.id;
    }
    public void setId(String id)
    {

      this.id=id;
    }





}